Workplace Productivity Dashboard



Problem Statement

The Workplace Productivity Dashboard is one of my projects while volunteering as a data analyst through the website Catchafire.org. A client that I worked with is Ms. Nicola which is the project manager for the East Baltimore Research Project, a U.S. non-profit organization. Ms. Nicola wanted a dashboard summarizing the activities of the employees of the organization, highlighting how each employee spends their time in the organization. The names in the dashboard published in the website are aliased for privacy reasons.


Methodology

Data Collection

The data collection was not necesary for this project. The data for wokplace activities was already provided by Ms. Nicola in an Excel spreadsheet. The Excel spreadsheet contained the employees' activities from January to June. The columns were Name, Date, Task, Remarks and Hours rendered for the activity.


Data Cleaning

Data Cleaning was essential to the project. Missing/Uncategorized items, mispelled items, inconsistent punctuation and capitalization were fixed in the spreadsheet to avoid errors in data analysis and visualization.


Data Visualization

For the data visualization, the design chosen was a yellow and green theme complimenting the organization's logo. Each employee's activity was visualized using a pie chart. A bar chart was used to visualize the overall task summary which included the breakdown of all the employees' activities such as the task, hours rendered per task and the overall hours rendered. The overall layout of the dashboard may be a little bit unorthodoxed but I believe it was still able to utilize effective data storytelling.


Conclusion

  • N.Wilson (Project Manager) has the most number of contribution hours in the non-profit organization.
  • K.Davis and A.Smith had the least number of hours in the organization. There is, however, a lack of context of the positions of Davis and Smith wherein they could have been less essential to the project or have been employed on a project-based contract.
  • The other employees average at around 150 hours. Assuming all deliverables are done on time, this could be the KPI of hours that N.Wilson implement in the future.
  • All employees spend at least 50% of their time in team meetings.

Additional Insights

Overall, the project was fulfilling. At the same time, the ability to generate impact through data analytics skills is rewarding. The experience was a good opportunity to gain confidence in my abilities and upskill my Data Visualization expertise through Microsoft PowerBI.